Create Drill through Page 14


                       Create Drill through Page

     


-         

 


                Create Drill-Through KPI’S

·       First Duplicate the main page

·       Remove the whole visual and slicer except the KIP’S

·       Remove only one KPI that is Questions per day

·       Then Change the size Of the KPI’s using the below Info



1. TOTAL MEMBER KPI

STEP 1

·        Select Rectangle

General

-        X-Position 0

-        Y-Position 128

-        Width       208

-        Height     96

STEP 2

·       Select Card visual

·       Go to Format Tab

General

-        X-Position 16

-        Y-Position 176

-        Width       144

-        Height       48

                                     Data Label

-        Color Black

-        Text Size 32

Put everything else off

STEP 3

·       Select image 

General

-        X-Position 32

-        Y-Position 128

-        Width       112

-        Height     48

Put everything else off

STEP 4 

·       Select Text box

·       Go to The Format text 

General

-        X-Position 0

-        Y-Position 244

-        Width       208

-        Height     32

 

Create KPI’S

1. FIRST RESPONSE KPI

STEP 1

·        Select Rectangle

General

-        X-Position 208

-        Y-Position 128

-        Width       208

-        Height     96

Put everything else off

STEP 2

·       Select Card visual

·       Go to the Format   tab

General

-        X-Position 208

-        Y-Position 176

-        Width       112

-        Height       48

·       Data Label

-        Text Size 40

 

·       Select Hrs Card visual

·       Go to the Format tab

General

-        X-Position 320

-        Y-Position 176

-        Width       96

-        Height       48

                                     Data Label

-        Text size 30

 

 

Put everything else off

STEP 3

·       Select image 

·       Go to format Image

General

-        X-Position 256

-        Y-Position 128

-        Width       96

-        Height     48

Put everything else off

STEP 4

·       Select Text box

Format text box

General

-        X-Position 208

-        Y-Position 224

-        Width       208

-        Height     32

 

3. CONTRIBUTIONS KPI

STEP 1

    .·       Select Rectangle

 Â·       Go to Format Shape

General

-        X-Position 416

-        Y-Position 128

-        Width       224

-        Height     96

Put everything else off

STEP 2

·       Select Card visual

·       Go to Format Tab

General

-        X-Position 448

-        Y-Position 176

-        Width       160

-        Height       48

                                     

Put everything else off

STEP 3

·       Select the Image

·       Go to Format image

General

-        X-Position 464

-        Y-Position 128

-        Width       112

-        Height     48

Put everything else off

STEP 4 

·       Select Text box

Format text box

General

-        X-Position 416

-        Y-Position 224

-        Width       224

-        Height     32

4. TOTAL QUESTIONS

STEP 1

·        Select Rectangle

·       Go to Format Tab

General

-        X-Position 640

-        Y-Position 128

-        Width       208

-        Height     96                                    

Put everything else off

STEP 2

·       Select Card visual

·       Go to Format Tab

General

-        X-Position 672

-        Y-Position 176

-        Width       144

-        Height       48

                                     Data Label

-        Text Size 32

Put everything else off

STEP 3

·       Select image 

·       Go to format Image

General

-        X-Position 688

-        Y-Position 128

-        Width       112

-        Height      48

Put everything else off

STEP 4

·       Select Text box

·       Go to the Format text box

General

-        X-Position 640

-        Y-Position 224

-        Width       208

-        Height     32

5. NOT RESPONDED %

STEP 1

·     Select Rectangle

·       Go to Format Shape

General

-        X-Position 848

-        Y-Position 128

-        Width       208

-        Height     96

                           

Put everything else off

STEP 2

·       Select Card visual

·       Go to Format Tab

General

-        X-Position 880

-        Y-Position 176

-        Width        144

-        Height       48

                                     Data Label

-        Color Black

-        Text Size 32

Put everything else off

STEP 3

·       Select image 

·       Go to Format image

General

-        X-Position 912

-        Y-Position 128

-        Width       80

-        Height      48

Put everything else off

STEP 4

·       Select Text box

·       Go to the Format text box

General

-        X-Position 848

-        Y-Position 224

-        Width       208

-        Height     32

 

6. CORRECT ANSWERS %

STEP 1

·       Select Rectangle 

·       Go to Format Shape

General

-        X-Position 1056

-        Y-Position 128

-        Width       224

-        Height     96                                    

Put everything else off

STEP 2

·       Select Card visual

·       Go to Format Tab

General

-        X-Position 1104

-        Y-Position 176

-        Width        144

-        Height       48

                                     Data Label

-        Text Size 32

Put everything else off

STEP 3

·       Select image

·       Go to Format Tab

General

-        X-Position 1120

-        Y-Position 128

-        Width       96

-        Height      48

Put everything else off

STEP 4

·       Select Text box

·       Go to the Format text box

General

-        X-Position 1056

-        Y-Position 224

-        Width       224

-        Height     32

  Create the Drill- through Page Slicer 

·       Select Slicer Visualization

·       Drag and Drop GroupName from ADF_Groups

Format

·       General   

-        Orientation Horizontal

-        X-Position 0

-        Y-Position 80

-        Width       1264

-        Height      49

 

·       Off Slicer header

·       Items

       Font Color              #F1C40F

       Background           #34495E

       Text                         10

·       Off Background 



     To create Back Icon

   Â·       Go to Insert

·       Select Buttons and Back

·       Go to the Format button 

General


  ·       X Position 0

·       Y Position 48

·       Width        64

·       Height       32

    Button Text    Off

               Icon

·       Line color -------#F1C40F

·       Horizontal alignment-------Left

Fill

·       Color ---------#34495E

·       Background ----Off

·       Bolder ----------Off

·       Shadow ------ Off



How to setup drill through power bi desktop

https://www.youtube.com/watch?v=fXSkad9Tw2k